allocation unit

allocation unit page count statistics during deferred drop operations.

在延迟删除操作期间的分配单元页计数统计信息。

互联网摘选

average number of pages in one fragment in the leaf level of an in_row_data allocation unit.

IN_ROW_DATA分配单元的叶级别中的一个碎片的平均页数。

互联网摘选

for a heap, the total number of records in the in_row_data allocation unit.

对于堆，表示IN_ROW_DATA分配单元中的总记录数。

互联网摘选

the following example returns partition and allocation unit data for two tables

下列示例返回两个表的分区和分配单元数据

互联网摘选

the index key of a clustered index cannot contain varchar columns that have existing data in the row_overflow_data allocation unit.

聚集索引的索引键不能包含在ROW_OVERFLOW_DATA分配单元中具有现有数据的varchar列。

互联网摘选

for an index, total number of records applies to the current level of the b-tree in the in_row_data allocation unit.

对于索引，记录的总数应用于IN_ROW_DATA分配单元中b树的当前级别。

互联网摘选

for lob_data or row_overflow_data allocation units, total number of pages in the allocation unit.

对于LOB_DATA或ROW_OVERFLOW_DATA分配单元，表示该分配单元中的总页数。

互联网摘选

an allocation unit is one of three types

分配单元有下列三种类型

互联网摘选

catalog view can be queried for metadata about each allocation unit in the database.

目录视图中查询数据库中每个分配单元的元数据。

互联网摘选

for lob_data or row_overflow_data allocation units, the total number of records in the complete allocation unit.

对于LOB_DATA或ROW_OVERFLOW_DATA分配单元，表示整个分配单元中总记录数。

互联网摘选

for an index, the average record size applies to the current level of the b-tree in the in_row_data allocation unit.

对于索引，平均记录大小应用于IN_ROW_DATA分配单元中b树的当前级别。

互联网摘选

for a heap, the total number of data pages in the in_row_data allocation unit.

对于堆，表示IN_ROW_DATA分配单元中的数据页总数。

互联网摘选

number of ghost records ready for removal by the ghost cleanup task in the allocation unit.

分配单元中将被虚影清除任务删除的虚影记录数。

互联网摘选

information about extents that have changed since the last backup database statement per allocation unit.

有关每个分配单元中自最后一条BACKUPDATABASE语句之后更改的区的信息。

互联网摘选

therefore, each allocation unit has at least one iam page for each file on which it has extents.

因此，每个分配单元在有区的每个文件中至少有一个IAM页。

互联网摘选

for large object (lob) data, one row is returned for the lob_data allocation unit of each partition.

对于大型对象（LOB）数据，针对每个分区的LOB_DATA分配单元返回与其对应的一行。

互联网摘选

for an index, the total number of index pages in the current level of the b-tree in the in_row_data allocation unit.

对于索引，表示IN_ROW_DATA分配单元中b树的当前级别中的索引页总数。

互联网摘选

information about extents modified by bulk operations since the last backup log statement per allocation unit.

有关每个分配单元中自最后一条BACKUPLOG语句之后的大容量操作所修改的区的信息。

互联网摘选

total number of pages allocated or reserved by this allocation unit.

该分配单元分配或保留的总页数。

互联网摘选

for an index, average applies to the current level of the b-tree in the in_row_data allocation unit.

对于索引，平均百分比应用于IN_ROW_DATA分配单元中b树的当前级别。

互联网摘选

for lob_data or row_overflow_data allocation units, the average record size in the complete allocation unit.

对于LOB_DATA或ROW_OVERFLOW_DATA分配单元，表示整个分配单元中的平均记录大小。

互联网摘选

a heap or b-tree can have only one allocation unit of each type in a specific partition.

在堆或B树的特定分区中，每种类型只能有一个分配单元。

互联网摘选

this contention can be reduced by partitioning the object of which this allocation unit is a part.

通过将此分配单元属于其一部分的对象进行分区，可以减少此争用。

互联网摘选

for every partition used by a table (heap or clustered table), index, or indexed view, there is one row_overflow_data allocation unit.

对于表（堆或聚集表）、索引或索引视图使用的每个分区，都有一个ROW_OVERFLOW_DATA分配单元。

互联网摘选

an allocation unit can contain only one iam chain, and an iam chain must belong to only one allocation unit.

一个分配单元只能包含一个IAM链，而且一个IAM链也只能属于一个分配单元。

互联网摘选

because is the financial allocation unit, therefore needs to be able to go in through the personnel bureau test.

因为都是财政拨款的单位，所以需要通过人事局考试才能进去。

互联网摘选

number of ghost records retained by an outstanding snapshot isolation transaction in an allocation unit.

由分配单元中未完成的快照隔离事务保留的虚影记录数。

互联网摘选

a fragment is made up of physically consecutive leaf pages in the same file for an allocation unit.

碎片由分配单元中同一文件内的物理连续的叶级页组成。

互联网摘选

an allocation unit is a collection of pages within a heap or b-tree used to manage data based on their page type.

分配单元是堆或B树内用于根据页类型管理数据的页集合。

互联网摘选

all the iam pages for that allocation unit are linked in a chain.

该分配单元的所有IAM页都链接到一个链中。

互联网摘选